using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using XBLib.Dal;
using XBLib.Dal.AdoDal;
using XBLib.BusinessObject;

using System.Data.Common;
using DataInfo;

namespace KenLib.Dal
{
    public class frm_HumanListDao:BaseAdoDao
    {
        public DataTable humanlist(int type)
        {
            DbParameter param = _daoHelper.CreateParameter("@type", type, DbType.Int32);
            DbCommand dbcommand = _daoHelper.CreateCommand("sp_HumanList", CommandType.StoredProcedure, param);
            return _daoHelper.Query(dbcommand);
        }
        public DataTable humanlistbyName(int type, string name)
        {
            DbParameter param = _daoHelper.CreateParameter("@type", type, DbType.Int32);
            DbParameter param1 = _daoHelper.CreateParameter("@name", name, DbType.String);
            DbCommand dbcommand = _daoHelper.CreateCommand("sp_HumanListByName", CommandType.StoredProcedure, param,param1);
            return _daoHelper.Query(dbcommand);
        }
    }
}
